| 翻訳と辞書 |
| Log shipping ： ウィキペディア英語版 |
Log shipping
Log shipping is the process of automating the backup of a database and transaction log files on a primary (production) database server, and then restoring them onto a standby server. This technique is supported by Microsoft SQL Server,〔( How to Perform SQL Server Log Shipping ), "What is Log Shipping". Retrieved on 2008-12-16.〕 4D Server, MySQL〔(【引用サイトリンク】title=MySQL :: MySQL 5.7 Reference Manual :: 17.1 Configuring Replication )〕 and PostgreSQL. Similar to replication, the primary purpose of log shipping is to increase database availability by maintaining a backup server that can replace production server quickly.
Although the actual failover mechanism in log shipping is manual, this implementation is often chosen due to its low cost in human and server resources, and ease of implementation. As comparison, SQL server clusters enable automatic failover, but at the expense of much higher storage costs. Compared to database replication, log shipping does not provide as much in terms of reporting capabilities, but also backs up system tables along with data tables, and locks standby server from users' modifications. A replicated server can be modified (e.g. views) and therefore is not suitable for failover purposes.
==References==
抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』
■ウィキペディアで「Log shipping」の詳細全文を読む
スポンサード リンク
| 翻訳と辞書 : 翻訳のためのインターネットリソース |
Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.
|
|